SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001296s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 503893 LIMIT 1 [ RunTime:0.000310s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 503893 [ RunTime:0.001467s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (198980,443116,974181,958176,68257,901273,964758,49910,25743,769596,130044,307075,670337,538579,665286,1015404,45814,616644,247788,1045330,802867,1043641,402828,938379,274436,256538,227769,137812,206447,359709,278867,596842,664119,538187,607961,538043,356716,111094,1021489,274803,272,504766,933126,6443,313136,191511,141898,494042,663351,176205,98209,102521,657705,549893,642498,538086,659531,651459,697557,867265) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000975s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 503893 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000363s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 503893 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000628s ]