SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001229s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1021492 LIMIT 1 [ RunTime:0.000376s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1021492 [ RunTime:0.002076s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (580840,163663,147054,86210,567301,331749,1033134,719508,235639,76769,840558,389487,435811,819334,666722,885388,284379,331546,760300,181873,747708,792979,358917,296429,643283,28389,49712,1033997,476073,767137,694217,552755,725814,496379,662757,382701,58236,387534,488448,217638,756298,985034,114134,435774,185126,253340,870429,738719,622151,744059,434599,846843,486231,863472,529281,777144,21576,723621,436197,231420) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001192s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1021492 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000386s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1021492 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000552s ]