SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001178s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 441984 LIMIT 1 [ RunTime:0.000343s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 441984 [ RunTime:0.001742s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (259191,98975,818300,894640,44714,17275,1019142,538593,611101,235784,788201,456176,304685,534148,635396,1012867,659849,588836,603999,407750,248569,765689,394046,547571,477355,199000,899939,661281,601445,921964,400214,703032,451538,1001380,91608,305213,165878,819472,537606,542443,926588,395000,633799,537019,290017,314692,328138,415768,81593,986879,411888,1044482,238593,12386,66582,435896,644614,655231,551796,279542) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001037s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 441984 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000364s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 441984 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000536s ]