SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003415s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 284189 LIMIT 1 [ RunTime:0.001647s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 284189 [ RunTime:0.001678s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (475822,864157,108588,281109,811379,468935,351899,536437,542559,483401,259657,351687,695522,70582,672004,1040531,829893,794242,255078,252061,160703,112400,35966,387683,344592,478790,518334,622436,147427,1039719,631222,99726,430944,1033979,185235,157528,184784,481439,64808,393131,175737,126238,462873,283326,1025493,167354,777386,451005,273803,156026,862026,471730,129982,261451,709937,155048,43662,97985,91068,538877) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001031s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 284189 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000329s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 284189 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000477s ]