SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001276s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 331192 LIMIT 1 [ RunTime:0.000363s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 331192 [ RunTime:0.002084s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (444802,158196,529375,725362,971521,850725,857873,77489,442966,734456,602800,981859,181225,568791,698672,986782,893186,1020112,13231,553968,909759,590546,862212,148559,164736,695792,144461,266133,677516,538601,7141,624466,680112,495904,950595,222165,739280,350776,978589,163052,233406,511850,530089,1042718,416237,1832,703801,340619,644445,140560,351318,1035336,119450,460830,416651,639430,212213,387073,309473,407559) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000998s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 331192 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000388s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 331192 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000567s ]