SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001300s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1020106 LIMIT 1 [ RunTime:0.001417s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1020106 [ RunTime:0.001619s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (827234,280804,347176,1022130,408041,709108,456205,692494,431323,602300,890179,575040,781793,200829,256204,1034421,1038555,522813,600159,402289,299656,735219,441723,891375,686463,613442,213474,946497,885630,22137,561817,904770,515238,172769,515084,33809,1005089,655374,779731,449107,511206,538873,203044,64677,185827,925321,205586,336557,83288,302575,491900,845828,867609,628787,122452,900788,374545,96553,607464,231671) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001040s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1020106 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000337s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1020106 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000456s ]