SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001161s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 116838 LIMIT 1 [ RunTime:0.000314s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 116838 [ RunTime:0.002004s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (959617,481634,673342,601321,727160,266307,384605,639618,924437,467930,802994,760197,230982,631775,759635,590448,394650,971241,369886,258919,175679,318894,92887,755698,875703,20682,448837,387558,512364,483779,846074,746424,70839,554329,308670,258613,38734,756104,770566,828805,745691,55959,274282,869812,274247,556101,221600,634764,980167,886993,1000065,44146,862758,173518,774517,307085,830639,89251,150577,929230) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000950s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 116838 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000357s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 116838 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.003942s ]