SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001278s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 427301 LIMIT 1 [ RunTime:0.000366s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 427301 [ RunTime:0.001707s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (991404,765585,761987,1000891,786167,493660,800131,597557,64227,887760,846413,1007472,164542,380830,613586,623382,149343,745766,580315,866883,65408,40973,1044747,754039,515737,633814,68427,155261,747427,1007439,461231,358555,595884,585776,589564,835414,1025633,16945,542689,89922,574370,941870,329987,122787,246434,667937,55645,628091,659307,1008944,80527,305991,870920,677072,811139,875420,245317,470264,589159,323330) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.004830s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 427301 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000732s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 427301 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002697s ]