SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001605s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 503253 LIMIT 1 [ RunTime:0.000600s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 503253 [ RunTime:0.002861s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (174165,200975,593158,957237,562389,588774,370555,614812,411577,540453,46688,785838,580646,428549,589643,214337,651593,255989,684932,848046,524471,513494,809465,914642,748963,428841,435772,723881,739794,891329,72976,398689,109684,315736,951272,835844,201394,910472,287050,72483,746083,922696,553237,372267,862280,935268,725102,909280,753870,583036,778502,983026,737654,807705,411735,439611,329745,290209,475958,460563) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001700s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 503253 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000390s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 503253 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000608s ]